{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Lists","README"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Lists","index":0,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["ACTIVE PATIENTS","REG000",null,"Today"]
["Applied","REG001",null,"Last Week"]
["Permanent","REG002",null,"Last Month"]
["Temporary Resident < 16 days","REG003",null,"Last Year"]
["Temporary Resident 16 days to 3 months","REG004"]
["Transferred Out","REG005"]
["Immediately Necessary Treatment","REG006"]
["Emergency Treatment","REG007"]
["Child Health Surveillance","REG008"]
["Contraception","REG009"]
["Maternity","REG010"]
["Minor Surgery","REG011"]
["Private","REG012"]
["Referred","REG013"]
["Walk in Centre","REG014"]
["GP with Special Interest","REG015"]
["Minor Injury Clinic","REG016"]
["HMP Inmate","REG017"]
["Visitor (EC111)","REG018"]
["INCLUDE ALL","NONE"]

{"sheet":"README","index":1,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,1,3,2],[26,1,29,4]]}
[]
[null,"UPN Prescription Analysis for Scotland"]
[]
[null,"Enter Date Range",null,null,"Active Patients = Applied and Permanent"]
[null,"FROM","TO",null,"Registration Status"]
[null,"2018-08-01","2018-08-31",null,"INCLUDE ALL"]
[]
[]
[]
[]
[null,"Note: This ePS is about the electronic prescription, not the individual drugs on a script."]
[null,"Once the data has been compiled, the EPS2 sheet will provide the data defined within your date range"]
[null,"The other sheet tabs will provide various counts using PivotTables, which you may alter."]
[]
[]
[null,"NOTE:"]
[null,"This will only work if Vision is on DLM485 or above."]
[null,"Excel 2010 - Please \"Enable Content\" if a security Warning is displayed"]
[]
[null,"Excel 2007 - Please enable both Macros... and Data Connections"]
[]
[null,"Updated: 24/09/2018"]
[null,"Version: 2"]
[null,"Written by: Bradley Sieve"]
[]
[null,"Disclaimer"]
[null,"In using this Microsoft Excel report you hereby acknowledge that the software cannot be guaranteed error free and may also be subject to how data is being recorded by your practice, and further acknowledge that the existence of any such errors shall not make Vision responsible for any actions you carry out based on these results."]
[]
[]
[]
[null,"v2"]
[null,"Now includes Preferred Pharmacy and CHI_No"]